package com.shopFund.dao;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import com.shopFund.bean.UserFund;

@Mapper
public interface UserFundMapper {

	
	@Insert("insert into sys_userFund set id=#{id},money=#{money},userId=#{userId},score=#{score}")
	public int insert(UserFund userFund);
	
	
	@Select("select * from sys_userFund where userId=#{userId}")
	public UserFund getByUserId(String userId);
	
	@Select("select * from sys_userFund where id=#{id}")
	public UserFund get(String userId);
	@Delete("delete  from sys_userFund where userId=#{userId}")
	public int deleteByUserId(String userId);
	
}
